Welcome
Guest
, you are in:
<root>
•
Login
devio dbscript ScrewTurn Wiki
Navigation
¶
Main Page
Random Page
Create a new Page
All Pages
Categories
Navigation Paths
Administration
File Management
Create Account
Search the wiki
»
Discuss (0)
View Page Code
History
Production ProductModelProductDescriptionCulture (table)
Print
RSS
Modified on 2011/08/27 11:18
by
wikibot
Categorized as
Uncategorized
Production (schema)
Production Culture (table)
Production ProductDescription (table)
Production ProductModel (table)
Production vProductAndDescription (view)
dbo AccountNumber (type)
dbo Flag (type)
dbo OrderNumber (type)
dbo ufnGetAccountingEndDate (function)
dbo ufnGetAccountingStartDate (function)
dbo uspLogError (procedure)
dbo uspPrintError (procedure)
Person Address (table)
Person Contact (table)
Purchasing ShipMethod (table)
Sales (schema)
Sales CreditCard (table)
Sales CurrencyRate (table)
Sales Customer (table)
Sales SalesOrderDetail (table)
Sales SalesOrderHeaderSalesReason (table)
Sales SalesPerson (table)
Sales SalesTerritory (table)
Sales vSalesPersonSalesByFiscalYears (view)
dbo uspLogError (procedure)
HumanResources (schema)
HumanResources Employee (table)
Production BillOfMaterials (table)
Production Product (table)
dbo Name (type)
Production (schema)
Production ProductInventory (table)
Production WorkOrderRouting (table)
Production (schema)
Production Product (table)
Production WorkOrder (table)
Purchasing PurchaseOrderDetail (table)
Sales SalesOrderDetail (table)
dbo uspLogError (procedure)
dbo uspPrintError (procedure)
Production Product (table)
Production TransactionHistory (table)
Purchasing (schema)
Purchasing PurchaseOrderHeader (table)
Production (schema)
Production Culture (table)
Production ProductDescription (table)
Production ProductModel (table)
Production vProductAndDescription (view)
dbo AccountNumber (type)
dbo Flag (type)
dbo OrderNumber (type)
dbo ufnGetAccountingEndDate (function)
dbo ufnGetAccountingStartDate (function)
dbo uspLogError (procedure)
dbo uspPrintError (procedure)
Person Address (table)
Person Contact (table)
Purchasing ShipMethod (table)
Sales (schema)
Sales CreditCard (table)
Sales CurrencyRate (table)
Sales Customer (table)
Sales SalesOrderDetail (table)
Sales SalesOrderHeaderSalesReason (table)
Sales SalesPerson (table)
Sales SalesTerritory (table)
Sales vSalesPersonSalesByFiscalYears (view)
dbo uspLogError (procedure)
HumanResources (schema)
HumanResources Employee (table)
(10)
»
HumanResources uspUpdateEmployeePersonalInfo (procedure)
»
Sales SalesOrderHeader (table)
»
Production ProductModelProductDescriptionCulture (table)
[X]
»
Purchasing PurchaseOrderDetail (table)
»
Production TransactionHistory (table)
»
IX STREAMS_QUEUE_TABLE (table)
»
public qrtz_paused_trigger_grps (table)
»
Production Location (table)
»
dbo uspGetBillOfMaterials (procedure)
»
SH CAL_MONTH_SALES_MV (table)
»
HumanResources uspUpdateEmployeePersonalInfo (procedure)
»
Sales SalesOrderHeader (table)
»
Production ProductModelProductDescriptionCulture (table)
wikibot
¶
Table
Production.ProductModelProductDescriptionCulture
Description
Cross-reference table mapping product descriptions and the language the description is written in.
Columns
¶
Column
Data Type
Nullable
Default
Description
ProductModelID
int
not null
Primary key. Foreign key to ProductModel.ProductModelID.
ProductDescriptionID
int
not null
Primary key. Foreign key to ProductDescription.ProductDescriptionID.
CultureID
nchar(6)
not null
Culture identification number. Foreign key to Culture.CultureID.
ModifiedDate
datetime
not null
(getdate())
Date and time the record was last updated.
Primary Key
¶
Primary Key
Columns
PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID
ProductModelID, ProductDescriptionID, CultureID
Foreign Keys
¶
Relation
Column
Referenced Column
Production.Culture
CultureID
CultureID
Production.ProductDescription
ProductDescriptionID
ProductDescriptionID
Production.ProductModel
ProductModelID
ProductModelID
References
¶
Dependency Type
Object Type
Referenced Object
Schema
Schema
Production
Dependencies
¶
Reference Type
Object Type
Referencing Object
Select
View
Production.vProductAndDescription
ScrewTurn Wiki
version 3.0.1.400. Some of the icons created by
FamFamFam
.